USE [Training]
GO

IF NOT EXISTS (SELECT * from dbo.sysobjects WHERE id = OBJECT_ID(N'dbo.training_api_DepartmentUpdate'))
	EXEC('CREATE PROC dbo.training_api_DepartmentUpdate AS')
GO

ALTER PROC dbo.training_api_DepartmentUpdate
	@Title	nvarchar(200),
	@DepartmentID	int
AS
	UPDATE Department
	SET
		Title = @Title
	WHERE
		DepartmentID = @DepartmentID
